<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Help.aspx.cs" Inherits="Install_Help" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Creating Your Database</title>
</head>
<body margin="10px">
    <form id="form1" runat="server">
    <div style="padding:20px;">
    <h4>How do I create my database?</h4>
    <a href="default.aspx">Back</a>
        <p>
            The first step to working with SQL Express is to have a tool that is designed to
            do just that. You can get the SQL Management Studio Express tool for free from here:<br />
            <br />
            <a href="http://msdn.microsoft.com/vstudio/express/sql/download/">http://msdn.microsoft.com/vstudio/express/sql/download/</a><br />
            <br />
            Make sure that you select an installation with the Management Express tool.</p>
        <p>
            When SP1 and the tools are installed, open up SQL Management Studio and connect
            to your local Express Server. This will most likely be "localhost\SQLEXPRESS". Use
            Windows Authentication.</p>
        <p>
            To add a database, just right click on Databases and select "<strong>New Database</strong>".
            Name it something like "<strong>CSK2</strong>".</p>
        <p>
            <img src="../images/Help/dbsetup_1gif.gif" />&nbsp;</p>
        <p>
            You need to let the ASP worker process, which is the identity that ASP runs under,
            have "owner" permissions of these databases. To do this, drop open the new database
            and go to the security folder. Right-click and select "New/User". A dialog will
            pop up asking you for a name and rights assignments.
        </p>
        <p>
            Your ASP worker process should be named one of two things - on most Windows XP machines
            this process is named "[MACHINENAME]\<strong>ASPNET</strong>". On servers and other
            XP machines, this process is called "[MACHINENAME]\<strong>NETWORK SERVICE</strong>".
            Select one of these names, and enter that name in both the Username and Login Box:</p>
        <p>
            <img src="../images/Help/dbsetup_2gif.gif" />&nbsp;</p>
        <p>
            Finally, add this new user to the role of db_owner. This will allow for the creation
            of tables and SPs, and the execution of those SPs.</p>
        <p>
            &nbsp;</p>
        <p>
            &nbsp;</p>
        <p>
            &nbsp;</p>
    
    
    
    
    
    
    
    </div>
    </form>
</body>
</html>
